GL

2024-06-03 18:04| 来源: 网络整理| 查看: 265

GL_JE_SOURCES_B contains journal entry sources. Each journal entry in your Oracle General Ledger application is assigned a source name to indicate how it was created. This table has no foreign keys, other than the standard Who columns.

Details

Schema: FUSION

Object owner: GL

Object type: TABLE

Tablespace: REFERENCE

Primary Key Name Columns

GL_JE_SOURCES_B_PK

JE_SOURCE_NAME

Columns Name Datatype Length Precision Not-null Comments Flexfield-mapping JE_SOURCE_NAME VARCHAR2 25 Yes Journal source name unique identifier. JE_SOURCE_KEY VARCHAR2 25 Yes Journal source key unique identifier. OVERRIDE_EDITS_FLAG VARCHAR2 1 Yes Whether or not Journal sources is enabled. JOURNAL_REFERENCE_FLAG VARCHAR2 1 Yes Populate GL_IMPORT_REFERENCES with reference information from subledger. EFFECTIVE_DATE_RULE_CODE VARCHAR2 1 Yes Non-business day rule (Roll Date, Leave Alone, or Fail). JOURNAL_APPROVAL_FLAG VARCHAR2 1 Yes Whether or not approval is enabled for the journal set. IMPORT_USING_KEY_FLAG VARCHAR2 1 Yes Import using journal source key flag. ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Journal Sources (GL_JE_SOURCES) ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Sources (GL_JE_SOURCES) ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Sources (GL_JE_SOURCES) ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Sources (GL_JE_SOURCES) ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Sources (GL_JE_SOURCES) ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Journal Sources (GL_JE_SOURCES) ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. SINGLE_CURRENCY_JOURNAL_FLAG VARCHAR2 1 Indicates whether to limit a journal to a single currency. ORA_SEED_SET1 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. ORA_SEED_SET2 VARCHAR2 1 Yes Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. Foreign Keys Table Foreign Table Foreign Key Column gl_autorun_setup_exclusions gl_je_sources_b JE_SOURCE_NAME Indexes Index Uniqueness Tablespace Columns GL_JE_SOURCES_B_U1 Unique Default JE_SOURCE_NAME, ORA_SEED_SET1 GL_JE_SOURCES_B_U11 Unique Default JE_SOURCE_NAME, ORA_SEED_SET2 GL_JE_SOURCES_B_U2 Unique Default JE_SOURCE_KEY, ORA_SEED_SET1 GL_JE_SOURCES_B_U21 Unique Default JE_SOURCE_KEY, ORA_SEED_SET2

【本文地址】

公司简介

联系我们